load data
characterset  UTF8 
append into table I_ELEMENT_MACADDRESS
fields terminated by '|'
TRAILING NULLCOLS (
	TIMESTAMP DATE 'YYYYMMDDHH24MISS',       
	DEVICEMODEL,        
	DEVICECODE,   
	DEVICEIPADDRESS,    
	DEVICEAREACODE,     
	MACADDRESS,         
	MACADDRESSTYPE,     
	PORTTYPE,           
	VLAN,               
	SHELFCODE,          
	SOLTCODE,           
	SUBSLOTCODE,       
	PORTCODE,
	PORTSPEED,
	PORTDOWNSTREAMCODE,                                       
	PORTDOWNSTREAMSPEED,                                  
	PORTUPSTREAMCODE,
	PORTUPSTREAMSPEED,           
	PEVLAN,                      
	CEVLAN,
	BATCHTIMESTAMP EXPRESSION "TO_DATE('2013-11-11 11:11:11','YYYY-MM-DD HH24:MI:SS')"--,
	--ID "SEQ_I_ELEMENT_MACADDRESS.NEXTVAL"  
)

--sqlldr userid=IOSSDEV/OBASDEV@DB control='D:\repository\workspaces\ioss_googlecode_java\com.obas.network.java.impl\src\com\obas\integration\element\service\impl\mac_table_all.ctl' data='D:\solution\ioss_yunnantelecom\integration_huawei\DATA\DATA_MAC_TABLE_ALL_20130704162047\DATA_MAC_TABLE_ALL_20130704162047.DAT' log='D:\solution\ioss_yunnantelecom\integration_huawei\DATA\DATA_MAC_TABLE_ALL_20130704162047\DATA_MAC_TABLE_ALL_20130704162047.log' parallel=true rows=5000 bindsize=10485760
